2015-01-30 - 10735.3800 - Enhancement - Japan Retail Stores to BEx Queries #BExQueriesforCrystalReportsAnalysisTool
Enhancement
10735.3800 - Japan Retail Stores to BEx Queries
Purpose
Need to remove the exclusion of following Japan Retail Stores in BEx Queries:
1017052
1017053
1017058
1017059
1017060
1017061
1017062
Admin Info
Purpose
|
Need to remove Exclusion of Japan Retail Stores in BEx Queries.
|
Requested By
|
Matthew Reeves
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
01/30/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
0SOLD_TO & 0CUSTOMER info objects.
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
28
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
00
|
6
|
Transports
|
02
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
Japan Retail Customers Include.xlsx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email from Greg:
We would like to make a change to some of the BW queries. We need to include the Japan retail stores on all Global or Japan queries where they are currently excluded. Global queries meaning any queries that aren’t hitting a regional InfoProvider, and then obviously all the queries hitting the Japan InfoProviders. This would include all analysis sources and crystal report sources. We would like to get this done on the analysis sources first if you could. So if you could do them early in the morning when you come in that would be great. Then finish with the rest of the queries after. The Japan retail stores that need to be removed from the exclusion list are:
1017052
1017053
1017058
1017059
1017060
1017061
1017062
In Scope:
Need to include the Japan Retail stores from BEx Queries where they are excluded currently.
Out of Scope:
Other regions and global BEx queries.
Solution Summary
1. Need to find the list of all BEx Queries in which the Japan retail stores are currently excluded.
2. Need to create a Open transport request in BPD(BW 7.3 Development).
3. Need to include the Japan Retail customers from all the BEx Queries where they are currently excluded ie remove the Japan IC customers from list.
4. Need to collect all BEx queries belonging to a infoprovider into separate transport request.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check whether the changes are collected into the transport request.
|
All the changes should be collected into the transport Rrquest.
|
2
|
Check if the Japan Retail stores specified are removed from the excluded list.
|
All the specified Japan Retail stores are removed from the exclusion list.
|
Solution Details
1. Need to find the list of all BEx Queries(Analysis Queries, Global Queries & Regional Queries) in which the Japan retail stores are currently excluded.
2. Need to create a Open transport requests in BPD(BW 7.3 Development).
3. Need to include the Japan Retail customers from all the BEx Queries where they are currently excluded ie remove the Japan IC customers from list.
4. Need to collect all BEx queries belonging to a infoprovider into separate transport request.
Issues
None